﻿USE KwaiXiaoDianDB;
GO


--商品表添加状态字段status
if not exists(select * from syscolumns where id=object_id('t_product') and name='status')
begin
	ALTER TABLE dbo.t_product ADD status TINYINT NULL;
END
GO

--默认为在架
UPDATE dbo.t_product SET status=1;